﻿CREATE TABLE [flcr].[SERVICE_TYPE] (
    [SERVICE_TYPE_ID]    INT           IDENTITY (1, 1) NOT NULL,
    [AUDIT_USER]         VARCHAR (100) NOT NULL,
    [AUDIT_DTTM]         DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]      INT           NOT NULL,
    [AUDIT_MOD_USER]     VARCHAR (100) NOT NULL,
    [AUDIT_MOD_DTTM]     DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ]  INT           NOT NULL,
    [BUILTIN]            BIT           NOT NULL,
    [ACTIVE_FLG]         BIT           NOT NULL,
    [SORT_ORDER]         INT           NOT NULL,
    [SERVICE_TYPE]       INT           NOT NULL,
    [SERVICE_TYPE_NAME]  VARCHAR (100) NOT NULL,
    [SERVICE_TYPE_DESC]  VARCHAR (250) NOT NULL,
    [SERVICE_TYPE_GROUP] INT           NOT NULL,
    [PARENT_ID]          INT           NULL
);

